Limitations and considerations
The following limitations apply:
- Only one Qlik Replicate task can be run per SAP Sybase ASE database.
- Zero values located at the end of binary data type strings are truncated when replicated to the target database. For example, 0x0000000000000000000000000100000100000000 in the source table will become 0x00000000000000000000000001000001 in the target table.
-
Qlik Replicate creates the target table with columns that do not allow NULL values, if the database default is not to allow NULL values. Consequently, if a Full Load or CDC replication task contains empty values, errors will occur.
To prevent this from happening:
- Right-click the database name and select Properties from the context menu.
- In the Options tab, select Allow nulls by default and then click OK.
-
Replicating data with 4-byte emoji characters is not supported.
-
To prevent deadlocks when performing a full parallel load of partitioned tables into Sybase ASE, it is strongly recommended to enable the Create primary key or unique index after full load completes option in the Full Load settings.
See also: Parallel Load.